Profiling Report

Dataset statistics

Number of variables	46
Number of observations	46927
Missing cells	243504
Missing cells (%)	11.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	14.0 MiB
Average record size in memory	313.0 B

Variable types

Numeric	22
DateTime	2
Categorical	13
Text	4
Boolean	5

Alerts

`booking_datetime` is highly overall correlated with `checkin_date` and 2 other fields	High correlation
`checkin_date` is highly overall correlated with `booking_datetime` and 1 other fields	High correlation
`checkout_date` is highly overall correlated with `booking_datetime` and 1 other fields	High correlation
`hotel_star_rating` is highly overall correlated with `price_per_guest_per_night`	High correlation
`no_of_adults` is highly overall correlated with `no_of_room` and 1 other fields	High correlation
`no_of_room` is highly overall correlated with `no_of_adults`	High correlation
`language` is highly overall correlated with `original_payment_currency`	High correlation
`original_selling_amount` is highly overall correlated with `amount_nights` and 1 other fields	High correlation
`distance_booking_checkin` is highly overall correlated with `booking_datetime`	High correlation
`amount_guests` is highly overall correlated with `no_of_adults`	High correlation
`amount_nights` is highly overall correlated with `original_selling_amount`	High correlation
`price_per_guest_per_night` is highly overall correlated with `hotel_star_rating` and 1 other fields	High correlation
`charge_option` is highly overall correlated with `pay_now`	High correlation
`original_payment_currency` is highly overall correlated with `language`	High correlation
`pay_now` is highly overall correlated with `charge_option`	High correlation
`no_of_extra_bed` is highly imbalanced (96.1%)	Imbalance
`original_payment_method` is highly imbalanced (58.3%)	Imbalance
`original_payment_type` is highly imbalanced (91.4%)	Imbalance
`request_latecheckin` is highly imbalanced (82.6%)	Imbalance
`request_airport` is highly imbalanced (93.7%)	Imbalance
`request_earlycheckin` is highly imbalanced (78.8%)	Imbalance
`request_nonesmoke` has 20030 (42.7%) missing values	Missing
`request_latecheckin` has 20030 (42.7%) missing values	Missing
`request_highfloor` has 20030 (42.7%) missing values	Missing
`request_largebed` has 20030 (42.7%) missing values	Missing
`request_twinbeds` has 20030 (42.7%) missing values	Missing
`request_airport` has 20030 (42.7%) missing values	Missing
`request_earlycheckin` has 20030 (42.7%) missing values	Missing
`hotel_brand_code` has 34699 (73.9%) missing values	Missing
`hotel_chain_code` has 34343 (73.2%) missing values	Missing
`cancellation_datetime` has 34250 (73.0%) missing values	Missing
`original_selling_amount` is highly skewed (γ1 = 36.55009602)	Skewed
`h_booking_id` has unique values	Unique
`hotel_star_rating` has 2060 (4.4%) zeros	Zeros
`accommadation_type_name` has 938 (2.0%) zeros	Zeros
`no_of_children` has 42690 (91.0%) zeros	Zeros
`distance_booking_checkin` has 11952 (25.5%) zeros	Zeros

Reproduction

Analysis started	2023-06-08 12:13:06.359262
Analysis finished	2023-06-08 12:14:47.076128
Duration	1 minute and 40.72 seconds
Software version	ydata-profiling vv4.2.0
Download configuration	config.json

h_booking_id
Real number (ℝ)

Distinct	46927
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-1.7482761 × 10¹⁶

Minimum	-9.2231941 × 10¹⁸
Maximum	9.2233383 × 10¹⁸
Zeros	0
Zeros (%)	0.0%
Negative	23545
Negative (%)	50.2%
Memory size	366.7 KiB

Quantile statistics

Minimum	-9.2231941 × 10¹⁸
5-th percentile	-8.3231332 × 10¹⁸
Q1	-4.6146133 × 10¹⁸
median	-3.2064787 × 10¹⁶
Q3	4.5760991 × 10¹⁸
95-th percentile	8.2846133 × 10¹⁸
Maximum	9.2233383 × 10¹⁸
Range	-2.1169456 × 10¹⁴
Interquartile range (IQR)	9.1907124 × 10¹⁸

Descriptive statistics

Standard deviation	5.3247643 × 10¹⁸
Coefficient of variation (CV)	-304.57227
Kurtosis	-1.1991323
Mean	-1.7482761 × 10¹⁶
Median Absolute Deviation (MAD)	4.5955943 × 10¹⁸
Skewness	0.0033792406
Sum	-8.756789 × 10¹⁸
Variance	2.8353114 × 10³⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.861445259 × 10¹⁸	1	< 0.1%
-5.859385366 × 10¹⁸	1	< 0.1%
4.102580392 × 10¹⁸	1	< 0.1%
1.795941529 × 10¹⁸	1	< 0.1%
-5.721949141 × 10¹⁸	1	< 0.1%
-4.284526584 × 10¹⁸	1	< 0.1%
2.103613272 × 10¹⁸	1	< 0.1%
5.236811047 × 10¹⁸	1	< 0.1%
-2.3832694 × 10¹⁸	1	< 0.1%
-2.788888768 × 10¹⁸	1	< 0.1%
Other values (46917)	46917	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-9.223194056 × 10¹⁸	1	< 0.1%
-9.222713784 × 10¹⁸	1	< 0.1%
-9.222411208 × 10¹⁸	1	< 0.1%
-9.222220846 × 10¹⁸	1	< 0.1%
-9.220467519 × 10¹⁸	1	< 0.1%
-9.219746746 × 10¹⁸	1	< 0.1%
-9.219730436 × 10¹⁸	1	< 0.1%
-9.219588531 × 10¹⁸	1	< 0.1%
-9.219312947 × 10¹⁸	1	< 0.1%
-9.219139934 × 10¹⁸	1	< 0.1%

Value	Count	Frequency (%)
9.223338324 × 10¹⁸	1	< 0.1%
9.223221736 × 10¹⁸	1	< 0.1%
9.222651807 × 10¹⁸	1	< 0.1%
9.222015612 × 10¹⁸	1	< 0.1%
9.221958225 × 10¹⁸	1	< 0.1%
9.221798878 × 10¹⁸	1	< 0.1%
9.221611986 × 10¹⁸	1	< 0.1%
9.221457559 × 10¹⁸	1	< 0.1%
9.220807687 × 10¹⁸	1	< 0.1%
9.220787994 × 10¹⁸	1	< 0.1%

booking_datetime
Real number (ℝ)

Distinct	357
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	199.2134

Minimum	1
Maximum	365
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	1
5-th percentile	95
Q1	180
median	206
Q3	234
95-th percentile	262
Maximum	365
Range	364
Interquartile range (IQR)	54

Descriptive statistics

Standard deviation	49.987481
Coefficient of variation (CV)	0.2509243
Kurtosis	1.8416776
Mean	199.2134
Median Absolute Deviation (MAD)	27
Skewness	-1.0796464
Sum	9348487
Variance	2498.7483
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
183	541	1.2%
184	526	1.1%
186	505	1.1%
205	505	1.1%
199	500	1.1%
185	497	1.1%
213	491	1.0%
187	491	1.0%
193	490	1.0%
197	488	1.0%
Other values (347)	41893	89.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	8	< 0.1%
2	10	< 0.1%
3	9	< 0.1%
4	3	< 0.1%
5	9	< 0.1%
6	5	< 0.1%
7	10	< 0.1%
8	16	< 0.1%
9	17	< 0.1%
10	12	< 0.1%

Value	Count	Frequency (%)
365	11	< 0.1%
364	3	< 0.1%
363	4	< 0.1%
362	5	< 0.1%
361	8	< 0.1%
360	5	< 0.1%
359	1	< 0.1%
358	3	< 0.1%
357	7	< 0.1%
356	2	< 0.1%

checkin_date
Real number (ℝ)

Distinct	105
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	226.65112

Minimum	158
Maximum	272
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	158
5-th percentile	186
Q1	205
median	226
Q3	250
95-th percentile	267
Maximum	272
Range	114
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	26.196808
Coefficient of variation (CV)	0.11558208
Kurtosis	-1.1697685
Mean	226.65112
Median Absolute Deviation (MAD)	23
Skewness	0.0039606809
Sum	10636057
Variance	686.27273
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
209	864	1.8%
258	801	1.7%
208	784	1.7%
230	784	1.7%
265	771	1.6%
251	748	1.6%
188	705	1.5%
223	691	1.5%
216	669	1.4%
195	666	1.4%
Other values (95)	39444	84.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
158	1	< 0.1%
166	1	< 0.1%
167	1	< 0.1%
168	1	< 0.1%
172	5	< 0.1%
173	3	< 0.1%
174	7	< 0.1%
175	13	< 0.1%
176	14	< 0.1%
177	15	< 0.1%

Value	Count	Frequency (%)
272	482	1.0%
271	515	1.1%
270	406	0.9%
269	419	0.9%
268	427	0.9%
267	436	0.9%
266	547	1.2%
265	771	1.6%
264	647	1.4%
263	495	1.1%

checkout_date
Real number (ℝ)

Distinct	91
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	228.64479

Minimum	183
Maximum	273
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	183
5-th percentile	188
Q1	207
median	229
Q3	252
95-th percentile	269
Maximum	273
Range	90
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	26.114705
Coefficient of variation (CV)	0.11421518
Kurtosis	-1.1822042
Mean	228.64479
Median Absolute Deviation (MAD)	23
Skewness	0.0061513478
Sum	10729614
Variance	681.97779
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
210	999	2.1%
231	868	1.8%
259	843	1.8%
273	792	1.7%
189	784	1.7%
196	781	1.7%
266	774	1.6%
217	773	1.6%
252	763	1.6%
238	732	1.6%
Other values (81)	38818	82.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
183	504	1.1%
184	409	0.9%
185	413	0.9%
186	403	0.9%
187	424	0.9%
188	484	1.0%
189	784	1.7%
190	423	0.9%
191	402	0.9%
192	383	0.8%

Value	Count	Frequency (%)
273	792	1.7%
272	554	1.2%
271	444	0.9%
270	457	1.0%
269	454	1.0%
268	466	1.0%
267	661	1.4%
266	774	1.6%
265	552	1.2%
264	420	0.9%

hotel_id
Real number (ℝ)

Distinct	24969
Distinct (%)	53.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1341712.9

Minimum	1
Maximum	5823993
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	1
5-th percentile	10917.6
Q1	255829
median	798535
Q3	2284662
95-th percentile	4168202
Maximum	5823993
Range	5823992
Interquartile range (IQR)	2028833

Descriptive statistics

Standard deviation	1361519.7
Coefficient of variation (CV)	1.0147624
Kurtosis	0.077266214
Mean	1341712.9
Median Absolute Deviation (MAD)	675419
Skewness	1.0483226
Sum	6.296256 × 10¹⁰
Variance	1.853736 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6452	273	0.6%
461790	54	0.1%
304294	46	0.1%
3080111	42	0.1%
337607	36	0.1%
185945	34	0.1%
1603143	34	0.1%
43450	33	0.1%
4426497	32	0.1%
1270365	32	0.1%
Other values (24959)	46311	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	< 0.1%
16	2	< 0.1%
75	2	< 0.1%
85	1	< 0.1%
99	3	< 0.1%
122	2	< 0.1%
140	1	< 0.1%
148	1	< 0.1%
153	1	< 0.1%
168	4	< 0.1%

Value	Count	Frequency (%)
5823993	1	< 0.1%
5808200	1	< 0.1%
5799579	1	< 0.1%
5798032	1	< 0.1%
5797970	1	< 0.1%
5795465	1	< 0.1%
5790845	1	< 0.1%
5785518	1	< 0.1%
5771209	1	< 0.1%
5761104	1	< 0.1%

hotel_country_code
Real number (ℝ)

Distinct	126
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	76.486756

Minimum	0
Maximum	125
Zeros	380
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	183.4 KiB

Quantile statistics

Minimum	0
5-th percentile	24
Q1	57
median	80
Q3	109
95-th percentile	118
Maximum	125
Range	125
Interquartile range (IQR)	52

Descriptive statistics

Standard deviation	31.100448
Coefficient of variation (CV)	0.4066122
Kurtosis	-0.83994882
Mean	76.486756
Median Absolute Deviation (MAD)	29
Skewness	-0.24798175
Sum	3589294
Variance	967.2379
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
57	7357	15.7%
109	6331	13.5%
80	6136	13.1%
114	4062	8.7%
49	2883	6.1%
61	2718	5.8%
92	2128	4.5%
121	2105	4.5%
118	1445	3.1%
45	1295	2.8%
Other values (116)	10467	22.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	380	0.8%
1	2	< 0.1%
2	4	< 0.1%
3	10	< 0.1%
4	114	0.2%
5	835	1.8%
6	1	< 0.1%
7	6	< 0.1%
8	3	< 0.1%
9	5	< 0.1%

Value	Count	Frequency (%)
125	4	< 0.1%
124	3	< 0.1%
123	115	0.2%
122	2	< 0.1%
121	2105	4.5%
120	4	< 0.1%
119	1	< 0.1%
118	1445	3.1%
117	1	< 0.1%
116	18	< 0.1%

hotel_live_date
Date

Distinct	17476
Distinct (%)	37.2%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Minimum	1999-09-09 00:00:00
Maximum	2019-04-18 10:17:00

Histogram

Histogram with fixed size bins (bins=50)

hotel_star_rating
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.2239968

Minimum	-1
Maximum	5
Zeros	2060
Zeros (%)	4.4%
Negative	1
Negative (%)	< 0.1%
Memory size	366.7 KiB

Quantile statistics

Minimum	-1
5-th percentile	1
Q1	3
median	3
Q3	4
95-th percentile	5
Maximum	5
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1722628
Coefficient of variation (CV)	0.36360543
Kurtosis	0.72713638
Mean	3.2239968
Median Absolute Deviation (MAD)	1
Skewness	-0.79401111
Sum	151292.5
Variance	1.3742
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
3	14061	30.0%
4	12531	26.7%
5	5053	10.8%
2	5018	10.7%
3.5	3389	7.2%
0	2060	4.4%
2.5	1752	3.7%
1	1342	2.9%
4.5	1174	2.5%
1.5	546	1.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	1	< 0.1%
0	2060	4.4%
1	1342	2.9%
1.5	546	1.2%
2	5018	10.7%
2.5	1752	3.7%
3	14061	30.0%
3.5	3389	7.2%
4	12531	26.7%
4.5	1174	2.5%

Value	Count	Frequency (%)
5	5053	10.8%
4.5	1174	2.5%
4	12531	26.7%
3.5	3389	7.2%
3	14061	30.0%
2.5	1752	3.7%
2	5018	10.7%
1.5	546	1.2%
1	1342	2.9%
0	2060	4.4%

accommadation_type_name
Real number (ℝ)

Distinct	22
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.395785

Minimum	0
Maximum	21
Zeros	938
Zeros (%)	2.0%
Negative	0
Negative (%)	0.0%
Memory size	183.4 KiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	10
median	10
Q3	10
95-th percentile	16
Maximum	21
Range	21
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.1764249
Coefficient of variation (CV)	0.30554931
Kurtosis	2.770737
Mean	10.395785
Median Absolute Deviation (MAD)	0
Skewness	0.1664497
Sum	487843
Variance	10.089675
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
10	34255	73.0%
16	4553	9.7%
5	2319	4.9%
9	2075	4.4%
19	1180	2.5%
0	938	2.0%
14	454	1.0%
17	278	0.6%
3	270	0.6%
18	238	0.5%
Other values (12)	367	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	938	2.0%
1	5	< 0.1%
2	93	0.2%
3	270	0.6%
4	1	< 0.1%
5	2319	4.9%
6	37	0.1%
7	88	0.2%
8	1	< 0.1%
9	2075	4.4%

Value	Count	Frequency (%)
21	65	0.1%
20	11	< 0.1%
19	1180	2.5%
18	238	0.5%
17	278	0.6%
16	4553	9.7%
15	52	0.1%
14	454	1.0%
13	8	< 0.1%
12	3	< 0.1%

charge_option
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Pay Now	35335
Pay Later	11567
Pay at Check-in	25

Length

Max length	15
Median length	7
Mean length	7.4972404
Min length	7

Characters and Unicode

Total characters	351823
Distinct characters	18
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Pay Now
2nd row	Pay Now
3rd row	Pay Now
4th row	Pay Now
5th row	Pay Later

Common Values

Value	Count	Frequency (%)
Pay Now	35335	75.3%
Pay Later	11567	24.6%
Pay at Check-in	25	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pay	46927	50.0%
now	35335	37.6%
later	11567	12.3%
at	25	< 0.1%
check-in	25	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
a	58519	16.6%
	46952	13.3%
P	46927	13.3%
y	46927	13.3%
N	35335	10.0%
o	35335	10.0%
w	35335	10.0%
t	11592	3.3%
e	11592	3.3%
L	11567	3.3%
Other values (8)	11742	3.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	210992	60.0%
Uppercase Letter	93854	26.7%
Space Separator	46952	13.3%
Dash Punctuation	25	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	58519	27.7%
y	46927	22.2%
o	35335	16.7%
w	35335	16.7%
t	11592	5.5%
e	11592	5.5%
r	11567	5.5%
h	25	< 0.1%
c	25	< 0.1%
k	25	< 0.1%
Other values (2)	50	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
P	46927	50.0%
N	35335	37.6%
L	11567	12.3%
C	25	< 0.1%

Space Separator

Value	Count	Frequency (%)
	46952	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	25	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	304846	86.6%
Common	46977	13.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	58519	19.2%
P	46927	15.4%
y	46927	15.4%
N	35335	11.6%
o	35335	11.6%
w	35335	11.6%
t	11592	3.8%
e	11592	3.8%
L	11567	3.8%
r	11567	3.8%
Other values (6)	150	< 0.1%

Common

Value	Count	Frequency (%)
	46952	99.9%
-	25	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	351823	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	58519	16.6%
	46952	13.3%
P	46927	13.3%
y	46927	13.3%
N	35335	10.0%
o	35335	10.0%
w	35335	10.0%
t	11592	3.3%
e	11592	3.3%
L	11567	3.3%
Other values (8)	11742	3.3%

h_customer_id
Real number (ℝ)

Distinct	24392
Distinct (%)	52.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.5089212 × 10¹⁸

Minimum	-9.096408 × 10¹⁸
Maximum	9.2233353 × 10¹⁸
Zeros	0
Zeros (%)	0.0%
Negative	445
Negative (%)	0.9%
Memory size	366.7 KiB

Quantile statistics

Minimum	-9.096408 × 10¹⁸
5-th percentile	4.0199151 × 10¹⁷
Q1	2.2306526 × 10¹⁸
median	4.5488106 × 10¹⁸
Q3	6.8535869 × 10¹⁸
95-th percentile	8.7526647 × 10¹⁸
Maximum	9.2233353 × 10¹⁸
Range	-1.2700075 × 10¹⁷
Interquartile range (IQR)	4.6229344 × 10¹⁸

Descriptive statistics

Standard deviation	2.8042853 × 10¹⁸
Coefficient of variation (CV)	0.62194152
Kurtosis	0.11193679
Mean	4.5089212 × 10¹⁸
Median Absolute Deviation (MAD)	2.311866 × 10¹⁸
Skewness	-0.33204114
Sum	5.9925552 × 10¹⁸
Variance	7.8640161 × 10³⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.476281626 × 10¹⁸	258	0.5%
9.896276996 × 10¹⁷	124	0.3%
3.403039646 × 10¹⁸	113	0.2%
6.17110326 × 10¹⁸	108	0.2%
2.260038697 × 10¹⁸	94	0.2%
2.84968879 × 10¹⁸	65	0.1%
6.096800854 × 10¹⁸	62	0.1%
7.537464804 × 10¹⁸	51	0.1%
6.357426652 × 10¹⁷	49	0.1%
7.190936377 × 10¹⁸	49	0.1%
Other values (24382)	45954	97.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-9.096407971 × 10¹⁸	1	< 0.1%
-9.095945867 × 10¹⁸	1	< 0.1%
-9.077138756 × 10¹⁸	3	< 0.1%
-9.063637105 × 10¹⁸	1	< 0.1%
-9.029931 × 10¹⁸	2	< 0.1%
-9.020452036 × 10¹⁸	6	< 0.1%
-8.961035497 × 10¹⁸	1	< 0.1%
-8.931780579 × 10¹⁸	2	< 0.1%
-8.908509556 × 10¹⁸	1	< 0.1%
-8.896314417 × 10¹⁸	1	< 0.1%

Value	Count	Frequency (%)
9.223335348 × 10¹⁸	1	< 0.1%
9.223298569 × 10¹⁸	4	< 0.1%
9.223219011 × 10¹⁸	1	< 0.1%
9.223204826 × 10¹⁸	1	< 0.1%
9.222879283 × 10¹⁸	1	< 0.1%
9.222675043 × 10¹⁸	2	< 0.1%
9.222136928 × 10¹⁸	1	< 0.1%
9.221635623 × 10¹⁸	1	< 0.1%
9.221401145 × 10¹⁸	8	< 0.1%
9.221262823 × 10¹⁸	1	< 0.1%

customer_nationality
Text

Distinct	136
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Length

Max length	32
Median length	21
Mean length	8.8196134
Min length	4

Characters and Unicode

Total characters	413878
Distinct characters	55
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	27 ?
Unique (%)	0.1%

Sample

1st row	China
2nd row	Japan
3rd row	Taiwan
4th row	Turkey
5th row	South Korea

Value	Count	Frequency (%)
south	6364	10.0%
korea	6227	9.8%
malaysia	6068	9.5%
taiwan	5059	8.0%
thailand	3409	5.4%
united	3078	4.8%
china	2669	4.2%
japan	2330	3.7%
hong	2241	3.5%
kong	2241	3.5%
Other values (151)	23912	37.6%

Most occurring characters

Value	Count	Frequency (%)
a	68559	16.6%
i	37749	9.1%
n	33947	8.2%
o	24183	5.8%
e	22684	5.5%
t	16690	4.0%
	16667	4.0%
r	14661	3.5%
s	14628	3.5%
h	14514	3.5%
Other values (45)	149596	36.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	322079	77.8%
Uppercase Letter	75123	18.2%
Space Separator	16671	4.0%
Dash Punctuation	3	< 0.1%
Other Punctuation	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	68559	21.3%
i	37749	11.7%
n	33947	10.5%
o	24183	7.5%
e	22684	7.0%
t	16690	5.2%
r	14661	4.6%
s	14628	4.5%
h	14514	4.5%
l	14009	4.3%
Other values (16)	60455	18.8%

Uppercase Letter

Value	Count	Frequency (%)
K	11677	15.5%
S	11036	14.7%
T	8579	11.4%
N	7190	9.6%
M	6499	8.7%
U	5347	7.1%
A	4143	5.5%
C	3152	4.2%
I	3066	4.1%
O	2363	3.1%
Other values (15)	12071	16.1%

Space Separator

Value	Count	Frequency (%)
	16667	> 99.9%
	4	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	3	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	397202	96.0%
Common	16676	4.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	68559	17.3%
i	37749	9.5%
n	33947	8.5%
o	24183	6.1%
e	22684	5.7%
t	16690	4.2%
r	14661	3.7%
s	14628	3.7%
h	14514	3.7%
l	14009	3.5%
Other values (41)	135578	34.1%

Common

Value	Count	Frequency (%)
	16667	99.9%
	4	< 0.1%
-	3	< 0.1%
'	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	413874	> 99.9%
None	4	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	68559	16.6%
i	37749	9.1%
n	33947	8.2%
o	24183	5.8%
e	22684	5.5%
t	16690	4.0%
	16667	4.0%
r	14661	3.5%
s	14628	3.5%
h	14514	3.5%
Other values (44)	149592	36.1%

None

Value	Count	Frequency (%)
	4	100.0%

guest_is_not_the_customer
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

0	36872
1	10055

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	46927
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	36872	78.6%
1	10055	21.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	36872	78.6%
1	10055	21.4%

Most occurring characters

Value	Count	Frequency (%)
0	36872	78.6%
1	10055	21.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	46927	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	36872	78.6%
1	10055	21.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	46927	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	36872	78.6%
1	10055	21.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	46927	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	36872	78.6%
1	10055	21.4%

guest_nationality_country_name
Text

Distinct	144
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Length

Max length	32
Median length	26
Mean length	8.4160718
Min length	4

Characters and Unicode

Total characters	394941
Distinct characters	57
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	34 ?
Unique (%)	0.1%

Sample

1st row	China
2nd row	Japan
3rd row	Taiwan
4th row	Turkey
5th row	South Korea

Value	Count	Frequency (%)
south	6765	11.2%
korea	6634	11.0%
malaysia	6163	10.2%
taiwan	5347	8.9%
thailand	3514	5.8%
united	3211	5.3%
china	3075	5.1%
japan	2469	4.1%
hong	2287	3.8%
kong	2287	3.8%
Other values (162)	18660	30.9%

Most occurring characters

Value	Count	Frequency (%)
a	69572	17.6%
i	37621	9.5%
n	35710	9.0%
o	23356	5.9%
e	21766	5.5%
t	17532	4.4%
h	15545	3.9%
s	15086	3.8%
l	14393	3.6%
	13481	3.4%
Other values (47)	130879	33.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	321012	81.3%
Uppercase Letter	60439	15.3%
Space Separator	13485	3.4%
Other Punctuation	3	< 0.1%
Open Punctuation	1	< 0.1%
Close Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	69572	21.7%
i	37621	11.7%
n	35710	11.1%
o	23356	7.3%
e	21766	6.8%
t	17532	5.5%
h	15545	4.8%
s	15086	4.7%
l	14393	4.5%
r	13380	4.2%
Other values (16)	57051	17.8%

Uppercase Letter

Value	Count	Frequency (%)
S	11588	19.2%
K	9947	16.5%
T	8986	14.9%
M	6640	11.0%
C	3587	5.9%
U	3249	5.4%
I	3217	5.3%
J	2481	4.1%
H	2298	3.8%
A	2284	3.8%
Other values (15)	6162	10.2%

Space Separator

Value	Count	Frequency (%)
	13481	> 99.9%
	4	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
'	2	66.7%
&	1	33.3%

Open Punctuation

Value	Count	Frequency (%)
(	1	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	381451	96.6%
Common	13490	3.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	69572	18.2%
i	37621	9.9%
n	35710	9.4%
o	23356	6.1%
e	21766	5.7%
t	17532	4.6%
h	15545	4.1%
s	15086	4.0%
l	14393	3.8%
r	13380	3.5%
Other values (41)	117490	30.8%

Common

Value	Count	Frequency (%)
	13481	99.9%
	4	< 0.1%
'	2	< 0.1%
&	1	< 0.1%
(	1	< 0.1%
)	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	394937	> 99.9%
None	4	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	69572	17.6%
i	37621	9.5%
n	35710	9.0%
o	23356	5.9%
e	21766	5.5%
t	17532	4.4%
h	15545	3.9%
s	15086	3.8%
l	14393	3.6%
	13481	3.4%
Other values (46)	130875	33.1%

None

Value	Count	Frequency (%)
	4	100.0%

no_of_adults
Real number (ℝ)

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.3475611

Minimum	1
Maximum	30
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	4
Maximum	30
Range	29
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.3241378
Coefficient of variation (CV)	0.56404829
Kurtosis	33.488263
Mean	2.3475611
Median Absolute Deviation (MAD)	0
Skewness	4.2137414
Sum	110164
Variance	1.753341
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
2	32070	68.3%
1	5481	11.7%
4	4492	9.6%
3	2905	6.2%
6	926	2.0%
5	378	0.8%
8	301	0.6%
10	101	0.2%
7	81	0.2%
12	67	0.1%
Other values (11)	125	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5481	11.7%
2	32070	68.3%
3	2905	6.2%
4	4492	9.6%
5	378	0.8%
6	926	2.0%
7	81	0.2%
8	301	0.6%
9	49	0.1%
10	101	0.2%

Value	Count	Frequency (%)
30	1	< 0.1%
27	2	< 0.1%
20	1	< 0.1%
18	18	< 0.1%
17	2	< 0.1%
16	16	< 0.1%
15	4	< 0.1%
14	16	< 0.1%
13	3	< 0.1%
12	67	0.1%

no_of_children
Real number (ℝ)

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.14814499

Minimum	0
Maximum	10
Zeros	42690
Zeros (%)	91.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	10
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.52912642
Coefficient of variation (CV)	3.5716795
Kurtosis	25.197554
Mean	0.14814499
Median Absolute Deviation (MAD)	0
Skewness	4.4201626
Sum	6952
Variance	0.27997477
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	42690	91.0%
1	2117	4.5%
2	1726	3.7%
3	251	0.5%
4	109	0.2%
5	18	< 0.1%
6	12	< 0.1%
7	2	< 0.1%
10	1	< 0.1%
8	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	42690	91.0%
1	2117	4.5%
2	1726	3.7%
3	251	0.5%
4	109	0.2%
5	18	< 0.1%
6	12	< 0.1%
7	2	< 0.1%
8	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
10	1	< 0.1%
8	1	< 0.1%
7	2	< 0.1%
6	12	< 0.1%
5	18	< 0.1%
4	109	0.2%
3	251	0.5%
2	1726	3.7%
1	2117	4.5%
0	42690	91.0%

no_of_extra_bed
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

0	46416
1	483
2	22
3	5
5	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	46927
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	46416	98.9%
1	483	1.0%
2	22	< 0.1%
3	5	< 0.1%
5	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	46416	98.9%
1	483	1.0%
2	22	< 0.1%
3	5	< 0.1%
5	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	46416	98.9%
1	483	1.0%
2	22	< 0.1%
3	5	< 0.1%
5	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	46927	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	46416	98.9%
1	483	1.0%
2	22	< 0.1%
3	5	< 0.1%
5	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	46927	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	46416	98.9%
1	483	1.0%
2	22	< 0.1%
3	5	< 0.1%
5	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	46927	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	46416	98.9%
1	483	1.0%
2	22	< 0.1%
3	5	< 0.1%
5	1	< 0.1%

no_of_room
Real number (ℝ)

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.140303

Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	9
Range	8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.51904538
Coefficient of variation (CV)	0.45518197
Kurtosis	52.885359
Mean	1.140303
Median Absolute Deviation (MAD)	0
Skewness	5.9691302
Sum	53511
Variance	0.26940811
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
1	42320	90.2%
2	3426	7.3%
3	751	1.6%
4	244	0.5%
5	106	0.2%
6	32	0.1%
9	20	< 0.1%
7	16	< 0.1%
8	12	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	42320	90.2%
2	3426	7.3%
3	751	1.6%
4	244	0.5%
5	106	0.2%
6	32	0.1%
7	16	< 0.1%
8	12	< 0.1%
9	20	< 0.1%

Value	Count	Frequency (%)
9	20	< 0.1%
8	12	< 0.1%
7	16	< 0.1%
6	32	0.1%
5	106	0.2%
4	244	0.5%
3	751	1.6%
2	3426	7.3%
1	42320	90.2%

origin_country_code
Text

Distinct	141
Distinct (%)	0.3%
Missing	2
Missing (%)	< 0.1%
Memory size	366.7 KiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	93850
Distinct characters	27
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	21 ?
Unique (%)	< 0.1%

Sample

1st row	CN
2nd row	JP
3rd row	TW
4th row	TR
5th row	KR

Value	Count	Frequency (%)
kr	6298	13.4%
my	6185	13.2%
tw	5255	11.2%
th	4308	9.2%
jp	2530	5.4%
cn	2494	5.3%
hk	2424	5.2%
id	2263	4.8%
us	1960	4.2%
sg	1926	4.1%
Other values (131)	11282	24.0%

Most occurring characters

Value	Count	Frequency (%)
T	10075	10.7%
K	9274	9.9%
H	8972	9.6%
R	7083	7.5%
M	6936	7.4%
Y	6207	6.6%
W	5316	5.7%
N	5056	5.4%
S	4588	4.9%
P	4583	4.9%
Other values (17)	25760	27.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	93784	99.9%
Decimal Number	66	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	10075	10.7%
K	9274	9.9%
H	8972	9.6%
R	7083	7.6%
M	6936	7.4%
Y	6207	6.6%
W	5316	5.7%
N	5056	5.4%
S	4588	4.9%
P	4583	4.9%
Other values (16)	25694	27.4%

Decimal Number

Value	Count	Frequency (%)
1	66	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	93784	99.9%
Common	66	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	10075	10.7%
K	9274	9.9%
H	8972	9.6%
R	7083	7.6%
M	6936	7.4%
Y	6207	6.6%
W	5316	5.7%
N	5056	5.4%
S	4588	4.9%
P	4583	4.9%
Other values (16)	25694	27.4%

Common

Value	Count	Frequency (%)
1	66	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	93850	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	10075	10.7%
K	9274	9.9%
H	8972	9.6%
R	7083	7.5%
M	6936	7.4%
Y	6207	6.6%
W	5316	5.7%
N	5056	5.4%
S	4588	4.9%
P	4583	4.9%
Other values (17)	25760	27.4%

language
Real number (ℝ)

Distinct	49
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.379462

Minimum	0
Maximum	48
Zeros	466
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	183.4 KiB

Quantile statistics

Minimum	0
5-th percentile	8
Q1	8
median	26
Q3	37
95-th percentile	45
Maximum	48
Range	48
Interquartile range (IQR)	29

Descriptive statistics

Standard deviation	14.699654
Coefficient of variation (CV)	0.62874219
Kurtosis	-1.4965756
Mean	23.379462
Median Absolute Deviation (MAD)	17
Skewness	0.21910009
Sum	1097128
Variance	216.07983
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
8	17238	36.7%
27	6684	14.2%
43	5776	12.3%
37	3217	6.9%
26	2436	5.2%
45	2399	5.1%
44	1929	4.1%
16	1293	2.8%
24	765	1.6%
48	636	1.4%
Other values (39)	4554	9.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	466	1.0%
1	2	< 0.1%
2	13	< 0.1%
3	1	< 0.1%
4	17	< 0.1%
5	63	0.1%
6	148	0.3%
7	5	< 0.1%
8	17238	36.7%
9	480	1.0%

Value	Count	Frequency (%)
48	636	1.4%
47	4	< 0.1%
46	65	0.1%
45	2399	5.1%
44	1929	4.1%
43	5776	12.3%
42	90	0.2%
41	6	< 0.1%
40	9	< 0.1%
39	229	0.5%

original_selling_amount
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	26481
Distinct (%)	56.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	219.59182

Minimum	2.1
Maximum	49566.16
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	2.1
5-th percentile	17.7
Q1	50.585
median	107.78
Q3	243.01
95-th percentile	750.268
Maximum	49566.16
Range	49564.06
Interquartile range (IQR)	192.425

Descriptive statistics

Standard deviation	439.9447
Coefficient of variation (CV)	2.0034658
Kurtosis	3515.9943
Mean	219.59182
Median Absolute Deviation (MAD)	72.27
Skewness	36.550096
Sum	10304785
Variance	193551.34
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
122.63	14	< 0.1%
15	12	< 0.1%
37.05	12	< 0.1%
22	11	< 0.1%
45	11	< 0.1%
19.56	11	< 0.1%
222.94	10	< 0.1%
28.46	10	< 0.1%
30	10	< 0.1%
16.86	10	< 0.1%
Other values (26471)	46816	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.1	1	< 0.1%
2.27	1	< 0.1%
2.31	1	< 0.1%
2.5	1	< 0.1%
2.59	1	< 0.1%
2.64	1	< 0.1%
2.76	1	< 0.1%
2.8	1	< 0.1%
2.82	1	< 0.1%
2.9	1	< 0.1%

Value	Count	Frequency (%)
49566.16	1	< 0.1%
17942.82	1	< 0.1%
15430.5	1	< 0.1%
13015.52	1	< 0.1%
11672.15	1	< 0.1%
9562.86	1	< 0.1%
9074.52	1	< 0.1%
9065.76	1	< 0.1%
8024.56	1	< 0.1%
7437.78	1	< 0.1%

original_payment_method
Categorical

Distinct	36
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Visa	23088
MasterCard	13875
UNKNOWN	3210
American Express	2198
JCB	1124
Other values (31)	3432

Length

Max length	21
Median length	20
Mean length	6.8831163
Min length	3

Characters and Unicode

Total characters	323004
Distinct characters	49
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Alipay
2nd row	American Express
3rd row	Visa
4th row	MasterCard
5th row	Visa

Common Values

Value	Count	Frequency (%)
Visa	23088	49.2%
MasterCard	13875	29.6%
UNKNOWN	3210	6.8%
American Express	2198	4.7%
JCB	1124	2.4%
Alipay	945	2.0%
PayPal	557	1.2%
MayBank2U	430	0.9%
UnionPay - Creditcard	292	0.6%
K PLUS	206	0.4%
Other values (26)	1002	2.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
visa	23088	45.5%
mastercard	13875	27.3%
unknown	3210	6.3%
american	2198	4.3%
express	2198	4.3%
jcb	1124	2.2%
alipay	945	1.9%
paypal	557	1.1%
maybank2u	430	0.8%
unionpay	339	0.7%
Other values (43)	2784	5.5%

Most occurring characters

Value	Count	Frequency (%)
a	57861	17.9%
s	41874	13.0%
r	32986	10.2%
i	27345	8.5%
V	23088	7.1%
e	19220	6.0%
C	15988	4.9%
M	14788	4.6%
t	14581	4.5%
d	14574	4.5%
Other values (39)	60699	18.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	228931	70.9%
Uppercase Letter	89464	27.7%
Space Separator	3821	1.2%
Decimal Number	449	0.1%
Dash Punctuation	339	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	57861	25.3%
s	41874	18.3%
r	32986	14.4%
i	27345	11.9%
e	19220	8.4%
t	14581	6.4%
d	14574	6.4%
n	3570	1.6%
p	3303	1.4%
c	2737	1.2%
Other values (13)	10880	4.8%

Uppercase Letter

Value	Count	Frequency (%)
V	23088	25.8%
C	15988	17.9%
M	14788	16.5%
N	9652	10.8%
U	4185	4.7%
K	3449	3.9%
W	3411	3.8%
A	3382	3.8%
O	3222	3.6%
E	2248	2.5%
Other values (12)	6051	6.8%

Decimal Number

Value	Count	Frequency (%)
2	430	95.8%
7	19	4.2%

Space Separator

Value	Count	Frequency (%)
	3821	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	339	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	318395	98.6%
Common	4609	1.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	57861	18.2%
s	41874	13.2%
r	32986	10.4%
i	27345	8.6%
V	23088	7.3%
e	19220	6.0%
C	15988	5.0%
M	14788	4.6%
t	14581	4.6%
d	14574	4.6%
Other values (35)	56090	17.6%

Common

Value	Count	Frequency (%)
	3821	82.9%
2	430	9.3%
-	339	7.4%
7	19	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	323004	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	57861	17.9%
s	41874	13.0%
r	32986	10.2%
i	27345	8.5%
V	23088	7.1%
e	19220	6.0%
C	15988	4.9%
M	14788	4.6%
t	14581	4.5%
d	14574	4.5%
Other values (39)	60699	18.8%

original_payment_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Credit Card	46132
Invoice	612
Gift Card	183

Length

Max length	11
Median length	11
Mean length	10.940035
Min length	7

Characters and Unicode

Total characters	513383
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Credit Card
2nd row	Credit Card
3rd row	Credit Card
4th row	Credit Card
5th row	Credit Card

Common Values

Value	Count	Frequency (%)
Credit Card	46132	98.3%
Invoice	612	1.3%
Gift Card	183	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
card	46315	49.7%
credit	46132	49.5%
invoice	612	0.7%
gift	183	0.2%

Most occurring characters

Value	Count	Frequency (%)
C	92447	18.0%
r	92447	18.0%
d	92447	18.0%
i	46927	9.1%
e	46744	9.1%
t	46315	9.0%
	46315	9.0%
a	46315	9.0%
I	612	0.1%
n	612	0.1%
Other values (5)	2202	0.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	373826	72.8%
Uppercase Letter	93242	18.2%
Space Separator	46315	9.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	92447	24.7%
d	92447	24.7%
i	46927	12.6%
e	46744	12.5%
t	46315	12.4%
a	46315	12.4%
n	612	0.2%
v	612	0.2%
o	612	0.2%
c	612	0.2%

Uppercase Letter

Value	Count	Frequency (%)
C	92447	99.1%
I	612	0.7%
G	183	0.2%

Space Separator

Value	Count	Frequency (%)
	46315	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	467068	91.0%
Common	46315	9.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	92447	19.8%
r	92447	19.8%
d	92447	19.8%
i	46927	10.0%
e	46744	10.0%
t	46315	9.9%
a	46315	9.9%
I	612	0.1%
n	612	0.1%
v	612	0.1%
Other values (4)	1590	0.3%

Common

Value	Count	Frequency (%)
	46315	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	513383	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	92447	18.0%
r	92447	18.0%
d	92447	18.0%
i	46927	9.1%
e	46744	9.1%
t	46315	9.0%
	46315	9.0%
a	46315	9.0%
I	612	0.1%
n	612	0.1%
Other values (5)	2202	0.4%

original_payment_currency
Categorical

Distinct	50
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

MYR	6088
KRW	5995
TWD	5300
USD	3685
THB	3604
Other values (45)	22255

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	140781
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CNY
2nd row	JPY
3rd row	TWD
4th row	TRY
5th row	KRW

Common Values

Value	Count	Frequency (%)
MYR	6088	13.0%
KRW	5995	12.8%
TWD	5300	11.3%
USD	3685	7.9%
THB	3604	7.7%
CNY	2908	6.2%
HKD	2695	5.7%
JPY	2677	5.7%
SGD	1977	4.2%
IDR	1908	4.1%
Other values (40)	10090	21.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
myr	6088	13.0%
krw	5995	12.8%
twd	5300	11.3%
usd	3685	7.9%
thb	3604	7.7%
cny	2908	6.2%
hkd	2695	5.7%
jpy	2677	5.7%
sgd	1977	4.2%
idr	1908	4.1%
Other values (40)	10090	21.5%

Most occurring characters

Value	Count	Frequency (%)
D	18718	13.3%
R	17659	12.5%
Y	11789	8.4%
W	11352	8.1%
K	9238	6.6%
T	9034	6.4%
H	8063	5.7%
U	7111	5.1%
P	6972	5.0%
S	6444	4.6%
Other values (16)	34401	24.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	140781	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
D	18718	13.3%
R	17659	12.5%
Y	11789	8.4%
W	11352	8.1%
K	9238	6.6%
T	9034	6.4%
H	8063	5.7%
U	7111	5.1%
P	6972	5.0%
S	6444	4.6%
Other values (16)	34401	24.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	140781	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	18718	13.3%
R	17659	12.5%
Y	11789	8.4%
W	11352	8.1%
K	9238	6.6%
T	9034	6.4%
H	8063	5.7%
U	7111	5.1%
P	6972	5.0%
S	6444	4.6%
Other values (16)	34401	24.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	140781	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
D	18718	13.3%
R	17659	12.5%
Y	11789	8.4%
W	11352	8.1%
K	9238	6.6%
T	9034	6.4%
H	8063	5.7%
U	7111	5.1%
P	6972	5.0%
S	6444	4.6%
Other values (16)	34401	24.4%

is_user_logged_in
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.0 KiB

True	30549
False	16378

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	30549	65.1%
False	16378	34.9%

cancellation_policy_code
Text

Distinct	719
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Memory size	366.7 KiB

Length

Max length	20
Median length	19
Mean length	9.8295864
Min length	4

Characters and Unicode

Total characters	461273
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	348 ?
Unique (%)	0.7%

Sample

1st row	1D1N_1N
2nd row	3D1N_1N
3rd row	1D1N_1N
4th row	365D100P_100P
5th row	3D100P_100P

Value	Count	Frequency (%)
365d100p_100p	12793	27.3%
1d1n_1n	7026	15.0%
3d1n_1n	2712	5.8%
1d100p	2008	4.3%
3d1n_100p	1984	4.2%
1d100p_100p	1361	2.9%
7d100p_100p	1258	2.7%
3d100p_100p	1220	2.6%
2d100p	1175	2.5%
3d100p	1125	2.4%
Other values (709)	14265	30.4%

Most occurring characters

Value	Count	Frequency (%)
0	116602	25.3%
1	98713	21.4%
P	58967	12.8%
D	48674	10.6%
_	41142	8.9%
N	30034	6.5%
3	22793	4.9%
5	16343	3.5%
6	13603	2.9%
2	4778	1.0%
Other values (8)	9624	2.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	280592	60.8%
Uppercase Letter	139539	30.3%
Connector Punctuation	41142	8.9%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	116602	41.6%
1	98713	35.2%
3	22793	8.1%
5	16343	5.8%
6	13603	4.8%
2	4778	1.7%
7	4537	1.6%
4	2485	0.9%
8	454	0.2%
9	284	0.1%

Uppercase Letter

Value	Count	Frequency (%)
P	58967	42.3%
D	48674	34.9%
N	30034	21.5%
U	466	0.3%
K	466	0.3%
O	466	0.3%
W	466	0.3%

Connector Punctuation

Value	Count	Frequency (%)
_	41142	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	321734	69.7%
Latin	139539	30.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	116602	36.2%
1	98713	30.7%
_	41142	12.8%
3	22793	7.1%
5	16343	5.1%
6	13603	4.2%
2	4778	1.5%
7	4537	1.4%
4	2485	0.8%
8	454	0.1%

Latin

Value	Count	Frequency (%)
P	58967	42.3%
D	48674	34.9%
N	30034	21.5%
U	466	0.3%
K	466	0.3%
O	466	0.3%
W	466	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	461273	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	116602	25.3%
1	98713	21.4%
P	58967	12.8%
D	48674	10.6%
_	41142	8.9%
N	30034	6.5%
3	22793	4.9%
5	16343	3.5%
6	13603	2.9%
2	4778	1.0%
Other values (8)	9624	2.1%

is_first_booking
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.0 KiB

False	36484
True	10443

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	36484	77.7%
True	10443	22.3%

request_nonesmoke
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	20030
Missing (%)	42.7%
Memory size	366.7 KiB

1.0	19328
0.0	7569

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	80691
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	0.0
3rd row	0.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	19328	41.2%
0.0	7569	16.1%
(Missing)	20030	42.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	19328	71.9%
0.0	7569	28.1%

Most occurring characters

Value	Count	Frequency (%)
0	34466	42.7%
.	26897	33.3%
1	19328	24.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	53794	66.7%
Other Punctuation	26897	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	34466	64.1%
1	19328	35.9%

Other Punctuation

Value	Count	Frequency (%)
.	26897	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	80691	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	34466	42.7%
.	26897	33.3%
1	19328	24.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	80691	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	34466	42.7%
.	26897	33.3%
1	19328	24.0%

request_latecheckin
Categorical

IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	20030
Missing (%)	42.7%
Memory size	366.7 KiB

0.0	26195
1.0	702

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	80691
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	26195	55.8%
1.0	702	1.5%
(Missing)	20030	42.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	26195	97.4%
1.0	702	2.6%

Most occurring characters

Value	Count	Frequency (%)
0	53092	65.8%
.	26897	33.3%
1	702	0.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	53794	66.7%
Other Punctuation	26897	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	53092	98.7%
1	702	1.3%

Other Punctuation

Value	Count	Frequency (%)
.	26897	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	80691	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	53092	65.8%
.	26897	33.3%
1	702	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	80691	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	53092	65.8%
.	26897	33.3%
1	702	0.9%

request_highfloor
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	20030
Missing (%)	42.7%
Memory size	366.7 KiB

0.0	22844
1.0	4053

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	80691
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	22844	48.7%
1.0	4053	8.6%
(Missing)	20030	42.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	22844	84.9%
1.0	4053	15.1%

Most occurring characters

Value	Count	Frequency (%)
0	49741	61.6%
.	26897	33.3%
1	4053	5.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	53794	66.7%
Other Punctuation	26897	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	49741	92.5%
1	4053	7.5%

Other Punctuation

Value	Count	Frequency (%)
.	26897	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	80691	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	49741	61.6%
.	26897	33.3%
1	4053	5.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	80691	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	49741	61.6%
.	26897	33.3%
1	4053	5.0%

request_largebed
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	20030
Missing (%)	42.7%
Memory size	366.7 KiB

0.0	16391
1.0	10506

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	80691
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	1.0
3rd row	0.0
4th row	0.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
0.0	16391	34.9%
1.0	10506	22.4%
(Missing)	20030	42.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	16391	60.9%
1.0	10506	39.1%

Most occurring characters

Value	Count	Frequency (%)
0	43288	53.6%
.	26897	33.3%
1	10506	13.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	53794	66.7%
Other Punctuation	26897	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	43288	80.5%
1	10506	19.5%

Other Punctuation

Value	Count	Frequency (%)
.	26897	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	80691	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	43288	53.6%
.	26897	33.3%
1	10506	13.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	80691	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	43288	53.6%
.	26897	33.3%
1	10506	13.0%

request_twinbeds
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	20030
Missing (%)	42.7%
Memory size	366.7 KiB

0.0	22624
1.0	4273

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	80691
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	22624	48.2%
1.0	4273	9.1%
(Missing)	20030	42.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	22624	84.1%
1.0	4273	15.9%

Most occurring characters

Value	Count	Frequency (%)
0	49521	61.4%
.	26897	33.3%
1	4273	5.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	53794	66.7%
Other Punctuation	26897	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	49521	92.1%
1	4273	7.9%

Other Punctuation

Value	Count	Frequency (%)
.	26897	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	80691	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	49521	61.4%
.	26897	33.3%
1	4273	5.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	80691	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	49521	61.4%
.	26897	33.3%
1	4273	5.3%

request_airport
Categorical

IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	20030
Missing (%)	42.7%
Memory size	366.7 KiB

0.0	26698
1.0	199

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	80691
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	26698	56.9%
1.0	199	0.4%
(Missing)	20030	42.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	26698	99.3%
1.0	199	0.7%

Most occurring characters

Value	Count	Frequency (%)
0	53595	66.4%
.	26897	33.3%
1	199	0.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	53794	66.7%
Other Punctuation	26897	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	53595	99.6%
1	199	0.4%

Other Punctuation

Value	Count	Frequency (%)
.	26897	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	80691	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	53595	66.4%
.	26897	33.3%
1	199	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	80691	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	53595	66.4%
.	26897	33.3%
1	199	0.2%

request_earlycheckin
Categorical

IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	20030
Missing (%)	42.7%
Memory size	366.7 KiB

0.0	25996
1.0	901

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	80691
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	1.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	25996	55.4%
1.0	901	1.9%
(Missing)	20030	42.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	25996	96.7%
1.0	901	3.3%

Most occurring characters

Value	Count	Frequency (%)
0	52893	65.6%
.	26897	33.3%
1	901	1.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	53794	66.7%
Other Punctuation	26897	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	52893	98.3%
1	901	1.7%

Other Punctuation

Value	Count	Frequency (%)
.	26897	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	80691	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	52893	65.6%
.	26897	33.3%
1	901	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	80691	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	52893	65.6%
.	26897	33.3%
1	901	1.1%

hotel_area_code
Real number (ℝ)

Distinct	5057
Distinct (%)	10.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3025.0395

Minimum	1
Maximum	5896
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	1
5-th percentile	243
Q1	1477
median	3134
Q3	4572
95-th percentile	5602
Maximum	5896
Range	5895
Interquartile range (IQR)	3095

Descriptive statistics

Standard deviation	1733.8559
Coefficient of variation (CV)	0.573168
Kurtosis	-1.2487545
Mean	3025.0395
Median Absolute Deviation (MAD)	1549
Skewness	-0.11513251
Sum	1.4195603 × 10⁸
Variance	3006256.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3747	718	1.5%
1192	571	1.2%
643	419	0.9%
4463	404	0.9%
606	382	0.8%
104	372	0.8%
4364	342	0.7%
3156	335	0.7%
2553	322	0.7%
5891	302	0.6%
Other values (5047)	42760	91.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	7	< 0.1%
5	1	< 0.1%
6	5	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	7	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
5896	1	< 0.1%
5894	2	< 0.1%
5893	1	< 0.1%
5892	2	< 0.1%
5891	302	0.6%
5890	1	< 0.1%
5889	18	< 0.1%
5888	1	< 0.1%
5887	39	0.1%
5886	10	< 0.1%

hotel_brand_code
Real number (ℝ)

Distinct	850
Distinct (%)	7.0%
Missing	34699
Missing (%)	73.9%
Infinite	0
Infinite (%)	0.0%
Mean	479.07458

Minimum	0
Maximum	936
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	0
5-th percentile	50
Q1	253
median	481
Q3	741
95-th percentile	914
Maximum	936
Range	936
Interquartile range (IQR)	488

Descriptive statistics

Standard deviation	277.61635
Coefficient of variation (CV)	0.57948461
Kurtosis	-1.1793446
Mean	479.07458
Median Absolute Deviation (MAD)	243
Skewness	-0.0051064914
Sum	5858124
Variance	77070.837
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
777	293	0.6%
442	254	0.5%
51	222	0.5%
253	215	0.5%
593	205	0.4%
918	195	0.4%
520	176	0.4%
50	160	0.3%
789	157	0.3%
193	155	0.3%
Other values (840)	10196	21.7%
(Missing)	34699	73.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2	< 0.1%
1	3	< 0.1%
2	3	< 0.1%
3	35	0.1%
4	2	< 0.1%
6	13	< 0.1%
7	5	< 0.1%
8	3	< 0.1%
9	65	0.1%
10	28	0.1%

Value	Count	Frequency (%)
936	66	0.1%
935	11	< 0.1%
934	7	< 0.1%
933	58	0.1%
932	7	< 0.1%
931	28	0.1%
930	2	< 0.1%
929	1	< 0.1%
928	4	< 0.1%
927	2	< 0.1%

hotel_chain_code
Real number (ℝ)

Distinct	610
Distinct (%)	4.8%
Missing	34343
Missing (%)	73.2%
Infinite	0
Infinite (%)	0.0%
Mean	357.64781

Minimum	0
Maximum	680
Zeros	8
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	0
5-th percentile	28
Q1	181
median	355
Q3	575
95-th percentile	672
Maximum	680
Range	680
Interquartile range (IQR)	394

Descriptive statistics

Standard deviation	208.81905
Coefficient of variation (CV)	0.58386783
Kurtosis	-1.3361399
Mean	357.64781
Median Absolute Deviation (MAD)	209
Skewness	-0.058302719
Sum	4500640
Variance	43605.395
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
600	696	1.5%
296	607	1.3%
675	383	0.8%
55	363	0.8%
181	340	0.7%
386	279	0.6%
537	249	0.5%
587	232	0.5%
217	222	0.5%
583	214	0.5%
Other values (600)	8999	19.2%
(Missing)	34343	73.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8	< 0.1%
1	50	0.1%
2	39	0.1%
3	1	< 0.1%
4	2	< 0.1%
5	2	< 0.1%
7	3	< 0.1%
8	5	< 0.1%
9	1	< 0.1%
10	50	0.1%

Value	Count	Frequency (%)
680	3	< 0.1%
679	52	0.1%
678	117	0.2%
677	13	< 0.1%
676	2	< 0.1%
675	383	0.8%
674	15	< 0.1%
673	27	0.1%
672	26	0.1%
671	2	< 0.1%

hotel_city_code
Real number (ℝ)

Distinct	2402
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1498.0466

Minimum	0
Maximum	2808
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	0
5-th percentile	140
Q1	583
median	1572
Q3	2310
95-th percentile	2797
Maximum	2808
Range	2808
Interquartile range (IQR)	1727

Descriptive statistics

Standard deviation	909.02087
Coefficient of variation (CV)	0.60680414
Kurtosis	-1.4051834
Mean	1498.0466
Median Absolute Deviation (MAD)	875
Skewness	-0.16917617
Sum	70298832
Variance	826318.94
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2477	2525	5.4%
2797	1883	4.0%
1403	1794	3.8%
142	1295	2.8%
162	1163	2.5%
2249	1124	2.4%
437	1059	2.3%
2799	987	2.1%
1816	881	1.9%
2310	767	1.6%
Other values (2392)	33449	71.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	2	< 0.1%
3	10	< 0.1%
4	2	< 0.1%
5	20	< 0.1%
6	3	< 0.1%
8	29	0.1%
9	1	< 0.1%
10	2	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
2808	2	< 0.1%
2807	3	< 0.1%
2806	1	< 0.1%
2805	1	< 0.1%
2804	2	< 0.1%
2803	1	< 0.1%
2802	1	< 0.1%
2800	10	< 0.1%
2799	987	2.1%
2797	1883	4.0%

cancellation_datetime
Date

Distinct	347
Distinct (%)	2.7%
Missing	34250
Missing (%)	73.0%
Memory size	366.7 KiB

Minimum	2017-08-12 00:00:00
Maximum	2019-03-09 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

did_cancel
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.0 KiB

False	34250
True	12677

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	34250	73.0%
True	12677	27.0%

distance_booking_checkin
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	345
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.429284

Minimum	-1
Maximum	447
Zeros	11952
Zeros (%)	25.5%
Negative	328
Negative (%)	0.7%
Memory size	183.4 KiB

Quantile statistics

Minimum	-1
5-th percentile	0
Q1	0
median	9
Q3	37
95-th percentile	132
Maximum	447
Range	448
Interquartile range (IQR)	37

Descriptive statistics

Standard deviation	46.739778
Coefficient of variation (CV)	1.5882064
Kurtosis	7.9746826
Mean	29.429284
Median Absolute Deviation (MAD)	9
Skewness	2.5657421
Sum	1381028
Variance	2184.6069
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	11952	25.5%
1	2239	4.8%
2	1782	3.8%
3	1428	3.0%
4	1229	2.6%
5	1086	2.3%
6	996	2.1%
7	847	1.8%
8	838	1.8%
9	792	1.7%
Other values (335)	23738	50.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	328	0.7%
0	11952	25.5%
1	2239	4.8%
2	1782	3.8%
3	1428	3.0%
4	1229	2.6%
5	1086	2.3%
6	996	2.1%
7	847	1.8%
8	838	1.8%

Value	Count	Frequency (%)
447	1	< 0.1%
361	3	< 0.1%
359	1	< 0.1%
357	1	< 0.1%
356	1	< 0.1%
355	1	< 0.1%
353	1	< 0.1%
350	1	< 0.1%
349	2	< 0.1%
347	1	< 0.1%

amount_guests
Real number (ℝ)

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.4957061

Minimum	1
Maximum	30
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	3
95-th percentile	5
Maximum	30
Range	29
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.4588569
Coefficient of variation (CV)	0.58454674
Kurtosis	26.962429
Mean	2.4957061
Median Absolute Deviation (MAD)	0
Skewness	3.7545332
Sum	117116
Variance	2.1282633
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
2	29487	62.8%
4	5766	12.3%
1	5140	11.0%
3	3851	8.2%
6	1116	2.4%
5	707	1.5%
8	353	0.8%
7	125	0.3%
10	120	0.3%
9	77	0.2%
Other values (13)	185	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5140	11.0%
2	29487	62.8%
3	3851	8.2%
4	5766	12.3%
5	707	1.5%
6	1116	2.4%
7	125	0.3%
8	353	0.8%
9	77	0.2%
10	120	0.3%

Value	Count	Frequency (%)
30	1	< 0.1%
27	2	< 0.1%
24	1	< 0.1%
21	1	< 0.1%
20	6	< 0.1%
18	17	< 0.1%
17	3	< 0.1%
16	16	< 0.1%
15	6	< 0.1%
14	22	< 0.1%

amount_nights
Real number (ℝ)

Distinct	29
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.993671

Minimum	1
Maximum	30
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	183.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	5
Maximum	30
Range	29
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.7459906
Coefficient of variation (CV)	0.87576665
Kurtosis	44.530156
Mean	1.993671
Median Absolute Deviation (MAD)	0
Skewness	4.7506128
Sum	93557
Variance	3.0484831
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
1	25336	54.0%
2	10657	22.7%
3	5353	11.4%
4	2625	5.6%
5	1275	2.7%
6	550	1.2%
7	513	1.1%
8	158	0.3%
10	116	0.2%
9	101	0.2%
Other values (19)	243	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	25336	54.0%
2	10657	22.7%
3	5353	11.4%
4	2625	5.6%
5	1275	2.7%
6	550	1.2%
7	513	1.1%
8	158	0.3%
9	101	0.2%
10	116	0.2%

Value	Count	Frequency (%)
30	11	< 0.1%
29	1	< 0.1%
28	7	< 0.1%
27	2	< 0.1%
26	2	< 0.1%
25	1	< 0.1%
23	3	< 0.1%
22	1	< 0.1%
21	10	< 0.1%
20	12	< 0.1%

price_per_guest_per_night
Real number (ℝ)

Distinct	26848
Distinct (%)	57.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	44.164547

Minimum	0.083333333
Maximum	1770.22
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	366.7 KiB

Quantile statistics

Minimum	0.083333333
5-th percentile	7.805
Q1	17.13875
median	31.22
Q3	54.9525
95-th percentile	122.70175
Maximum	1770.22
Range	1770.1367
Interquartile range (IQR)	37.81375

Descriptive statistics

Standard deviation	45.586819
Coefficient of variation (CV)	1.0322039
Kurtosis	80.290278
Mean	44.164547
Median Absolute Deviation (MAD)	16.725
Skewness	5.1722562
Sum	2072509.7
Variance	2078.1581
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.5	16	< 0.1%
9.78	15	< 0.1%
6	14	< 0.1%
26.17	14	< 0.1%
7	13	< 0.1%
15	13	< 0.1%
122.63	13	< 0.1%
13.5	13	< 0.1%
7.5	13	< 0.1%
14.23	12	< 0.1%
Other values (26838)	46791	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.08333333333	1	< 0.1%
0.1923333333	1	< 0.1%
0.4233333333	1	< 0.1%
0.4875	1	< 0.1%
0.545	1	< 0.1%
0.570625	1	< 0.1%
0.6796875	1	< 0.1%
0.8333333333	1	< 0.1%
0.9225	1	< 0.1%
1	1	< 0.1%

Value	Count	Frequency (%)
1770.22	1	< 0.1%
1167.215	1	< 0.1%
915.3983333	1	< 0.1%
813.24	1	< 0.1%
739.645	1	< 0.1%
733.425	1	< 0.1%
730.28	1	< 0.1%
717.035	1	< 0.1%
715.705	1	< 0.1%
686.415	1	< 0.1%

costumer_guest_same_nation
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.0 KiB

True	41347
False	5580

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	41347	88.1%
False	5580	11.9%

pay_now
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.0 KiB

True	35335
False	11592

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	35335	75.3%
False	11592	24.7%

Auto

Heatmap
Table

	h_booking_id	booking_datetime	checkin_date	checkout_date	hotel_id	hotel_country_code	hotel_star_rating	accommadation_type_name	h_customer_id	no_of_adults	no_of_children	no_of_room	language	original_selling_amount	hotel_area_code	hotel_brand_code	hotel_chain_code	hotel_city_code	distance_booking_checkin	amount_guests	amount_nights	price_per_guest_per_night	charge_option	guest_is_not_the_customer	no_of_extra_bed	original_payment_method	original_payment_type	original_payment_currency	is_user_logged_in	is_first_booking	request_nonesmoke	request_latecheckin	request_highfloor	request_largebed	request_twinbeds	request_airport	request_earlycheckin	did_cancel	costumer_guest_same_nation	pay_now
h_booking_id	1.000	0.000	-0.007	-0.007	-0.003	-0.001	0.004	0.005	0.004	0.003	0.001	0.007	0.009	0.006	-0.000	-0.013	-0.010	0.002	-0.003	0.003	0.003	0.005	0.000	0.008	0.003	0.004	0.000	0.009	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004	0.000	0.000
booking_datetime	0.000	1.000	0.648	0.637	0.049	0.067	-0.067	-0.053	0.010	-0.088	-0.105	-0.070	-0.092	-0.318	0.021	0.045	0.002	-0.017	-0.618	-0.121	-0.242	-0.202	0.214	0.048	0.020	0.048	0.028	0.085	0.113	0.026	0.279	0.034	0.104	0.168	0.049	0.079	0.025	0.265	0.066	0.282
checkin_date	-0.007	0.648	1.000	0.998	0.037	-0.009	-0.014	-0.013	0.003	-0.034	-0.044	-0.029	-0.031	-0.076	0.008	0.003	-0.012	0.003	-0.010	-0.048	-0.070	-0.029	0.025	0.014	0.008	0.020	0.013	0.056	0.011	0.012	0.181	0.011	0.030	0.097	0.029	0.030	0.000	0.021	0.016	0.026
checkout_date	-0.007	0.637	0.998	1.000	0.036	-0.014	-0.013	-0.013	0.003	-0.035	-0.043	-0.028	-0.035	-0.044	0.007	0.001	-0.013	0.004	0.006	-0.049	-0.019	-0.023	0.018	0.016	0.011	0.023	0.016	0.055	0.015	0.006	0.179	0.009	0.023	0.092	0.027	0.027	0.000	0.022	0.009	0.023
hotel_id	-0.003	0.049	0.037	0.036	1.000	0.071	-0.171	-0.154	-0.010	-0.022	-0.048	-0.031	0.032	-0.110	0.006	-0.036	0.053	0.026	-0.034	-0.038	-0.021	-0.118	0.115	0.041	0.028	0.066	0.062	0.067	0.058	0.022	0.035	0.019	0.036	0.025	0.024	0.000	0.017	0.117	0.035	0.163
hotel_country_code	-0.001	0.067	-0.009	-0.014	0.071	1.000	-0.077	0.027	-0.009	0.105	0.003	0.004	0.132	-0.176	0.013	0.006	-0.016	0.067	-0.104	0.095	-0.074	-0.243	0.150	0.107	0.023	0.144	0.103	0.463	0.075	0.096	0.064	0.075	0.056	0.124	0.032	0.022	0.052	0.200	0.144	0.212
hotel_star_rating	0.004	-0.067	-0.014	-0.013	-0.171	-0.077	1.000	0.328	0.017	0.094	0.078	0.036	0.008	0.445	-0.002	-0.017	-0.097	-0.024	0.108	0.115	0.060	0.509	0.068	0.048	0.021	0.100	0.055	0.108	0.029	0.038	0.039	0.021	0.162	0.097	0.078	0.032	0.050	0.051	0.037	0.096
accommadation_type_name	0.005	-0.053	-0.013	-0.013	-0.154	0.027	0.328	1.000	0.003	0.152	0.063	0.030	-0.013	0.222	-0.017	0.011	-0.091	-0.001	0.069	0.158	0.016	0.215	0.032	0.045	0.028	0.055	0.022	0.086	0.022	0.040	0.045	0.016	0.088	0.051	0.052	0.035	0.027	0.062	0.033	0.046
h_customer_id	0.004	0.010	0.003	0.003	-0.010	-0.009	0.017	0.003	1.000	0.018	0.010	0.006	-0.004	0.015	-0.002	0.009	-0.025	-0.009	-0.005	0.021	0.005	0.008	0.020	0.023	0.000	0.030	0.063	0.057	0.032	0.015	0.017	0.043	0.007	0.029	0.024	0.000	0.000	0.018	0.014	0.030
no_of_adults	0.003	-0.088	-0.034	-0.035	-0.022	0.105	0.094	0.152	0.018	1.000	0.047	0.529	0.016	0.258	0.012	-0.025	-0.004	0.013	0.120	0.903	0.010	-0.100	0.042	0.032	0.106	0.000	0.019	0.036	0.018	0.008	0.029	0.000	0.007	0.099	0.080	0.033	0.000	0.045	0.008	0.059
no_of_children	0.001	-0.105	-0.044	-0.043	-0.048	0.003	0.078	0.063	0.010	0.047	1.000	0.064	0.058	0.161	-0.018	-0.036	-0.014	0.017	0.124	0.432	0.049	-0.015	0.064	0.020	0.037	0.025	0.007	0.044	0.006	0.038	0.000	0.011	0.010	0.067	0.025	0.020	0.031	0.043	0.014	0.091
no_of_room	0.007	-0.070	-0.029	-0.028	-0.031	0.004	0.036	0.030	0.006	0.529	0.064	1.000	0.015	0.219	-0.005	0.005	-0.001	-0.011	0.083	0.499	0.034	0.008	0.034	0.044	0.102	0.008	0.010	0.035	0.020	0.008	0.028	0.000	0.004	0.052	0.068	0.027	0.000	0.027	0.021	0.047
language	0.009	-0.092	-0.031	-0.035	0.032	0.132	0.008	-0.013	-0.004	0.016	0.058	0.015	1.000	0.043	-0.034	-0.020	-0.007	-0.040	0.126	0.036	-0.067	0.088	0.120	0.127	0.015	0.241	0.286	0.672	0.150	0.132	0.049	0.085	0.077	0.117	0.069	0.031	0.093	0.131	0.144	0.168
original_selling_amount	0.006	-0.318	-0.076	-0.044	-0.110	-0.176	0.445	0.222	0.015	0.258	0.161	0.219	0.043	1.000	-0.032	-0.010	-0.053	-0.042	0.451	0.298	0.612	0.752	0.006	0.013	0.000	0.000	0.000	0.034	0.000	0.000	0.004	0.000	0.000	0.000	0.000	0.022	0.000	0.018	0.000	0.013
hotel_area_code	-0.000	0.021	0.008	0.007	0.006	0.013	-0.002	-0.017	-0.002	0.012	-0.018	-0.005	-0.034	-0.032	1.000	0.044	0.020	0.013	-0.019	0.006	-0.000	-0.044	0.030	0.050	0.011	0.037	0.100	0.078	0.035	0.024	0.033	0.024	0.041	0.011	0.019	0.028	0.000	0.033	0.015	0.041
hotel_brand_code	-0.013	0.045	0.003	0.001	-0.036	0.006	-0.017	0.011	0.009	-0.025	-0.036	0.005	-0.020	-0.010	0.044	1.000	-0.050	-0.011	-0.052	-0.037	-0.037	0.044	0.066	0.033	0.014	0.058	0.021	0.099	0.031	0.043	0.036	0.023	0.040	0.012	0.016	0.012	0.025	0.070	0.049	0.093
hotel_chain_code	-0.010	0.002	-0.012	-0.013	0.053	-0.016	-0.097	-0.091	-0.025	-0.004	-0.014	-0.001	-0.007	-0.053	0.020	-0.050	1.000	-0.013	-0.011	-0.011	-0.022	-0.055	0.087	0.041	0.017	0.062	0.018	0.117	0.078	0.081	0.000	0.029	0.033	0.035	0.022	0.016	0.056	0.089	0.101	0.120
hotel_city_code	0.002	-0.017	0.003	0.004	0.026	0.067	-0.024	-0.001	-0.009	0.013	0.017	-0.011	-0.040	-0.042	0.013	-0.011	-0.013	1.000	0.020	0.017	0.009	-0.070	0.052	0.061	0.015	0.055	0.095	0.172	0.040	0.053	0.032	0.028	0.048	0.029	0.002	0.024	0.038	0.053	0.057	0.072
distance_booking_checkin	-0.003	-0.618	-0.010	0.006	-0.034	-0.104	0.108	0.069	-0.005	0.120	0.124	0.083	0.126	0.451	-0.019	-0.052	-0.011	0.020	1.000	0.158	0.336	0.304	0.210	0.044	0.008	0.041	0.026	0.081	0.122	0.031	0.201	0.029	0.106	0.131	0.028	0.069	0.035	0.278	0.061	0.287
amount_guests	0.003	-0.121	-0.048	-0.049	-0.038	0.095	0.115	0.158	0.021	0.903	0.432	0.499	0.036	0.298	0.006	-0.037	-0.011	0.017	0.158	1.000	0.029	-0.099	0.068	0.030	0.116	0.000	0.024	0.039	0.014	0.030	0.025	0.005	0.011	0.124	0.084	0.030	0.000	0.059	0.013	0.096
amount_nights	0.003	-0.242	-0.070	-0.019	-0.021	-0.074	0.060	0.016	0.005	0.010	0.049	0.034	-0.067	0.612	-0.000	-0.037	-0.022	0.009	0.336	0.029	1.000	0.134	0.068	0.032	0.000	0.007	0.012	0.088	0.018	0.034	0.061	0.014	0.054	0.020	0.012	0.058	0.000	0.112	0.033	0.095
price_per_guest_per_night	0.005	-0.202	-0.029	-0.023	-0.118	-0.243	0.509	0.215	0.008	-0.100	-0.015	0.008	0.088	0.752	-0.044	0.044	-0.055	-0.070	0.304	-0.099	0.134	1.000	0.018	0.015	0.000	0.000	0.079	0.036	0.013	0.000	0.000	0.012	0.000	0.004	0.014	0.008	0.000	0.041	0.020	0.028
charge_option	0.000	0.214	0.025	0.018	0.115	0.150	0.068	0.032	0.020	0.042	0.064	0.034	0.120	0.006	0.030	0.066	0.087	0.052	0.210	0.068	0.068	0.018	1.000	0.044	0.024	0.166	0.048	0.173	0.096	0.038	0.022	0.023	0.057	0.053	0.033	0.044	0.000	0.387	0.047	1.000
guest_is_not_the_customer	0.008	0.048	0.014	0.016	0.041	0.107	0.048	0.045	0.023	0.032	0.020	0.044	0.127	0.013	0.050	0.033	0.041	0.061	0.044	0.030	0.032	0.015	0.044	1.000	0.014	0.079	0.082	0.199	0.046	0.162	0.014	0.019	0.021	0.000	0.042	0.009	0.028	0.046	0.044	0.044
no_of_extra_bed	0.003	0.020	0.008	0.011	0.028	0.023	0.021	0.028	0.000	0.106	0.037	0.102	0.015	0.000	0.011	0.014	0.017	0.015	0.008	0.116	0.000	0.000	0.024	0.014	1.000	0.000	0.000	0.047	0.000	0.013	0.014	0.017	0.000	0.031	0.031	0.044	0.013	0.000	0.000	0.034
original_payment_method	0.004	0.048	0.020	0.023	0.066	0.144	0.100	0.055	0.030	0.000	0.025	0.008	0.241	0.000	0.037	0.058	0.062	0.055	0.041	0.000	0.007	0.000	0.166	0.079	0.000	1.000	0.341	0.163	0.123	0.096	0.048	0.033	0.093	0.094	0.055	0.000	0.054	0.148	0.096	0.237
original_payment_type	0.000	0.028	0.013	0.016	0.062	0.103	0.055	0.022	0.063	0.019	0.007	0.010	0.286	0.000	0.100	0.021	0.018	0.095	0.026	0.024	0.012	0.079	0.048	0.082	0.000	0.341	1.000	0.316	0.163	0.053	0.019	0.000	0.015	0.017	0.000	0.000	0.000	0.053	0.041	0.068
original_payment_currency	0.009	0.085	0.056	0.055	0.067	0.463	0.108	0.086	0.057	0.036	0.044	0.035	0.672	0.034	0.078	0.099	0.117	0.172	0.081	0.039	0.088	0.036	0.173	0.199	0.047	0.163	0.316	1.000	0.199	0.218	0.074	0.081	0.192	0.150	0.104	0.125	0.105	0.177	0.394	0.205
is_user_logged_in	0.000	0.113	0.011	0.015	0.058	0.075	0.029	0.022	0.032	0.018	0.006	0.020	0.150	0.000	0.035	0.031	0.078	0.040	0.122	0.014	0.018	0.013	0.096	0.046	0.000	0.123	0.163	0.199	1.000	0.479	0.019	0.050	0.119	0.022	0.000	0.000	0.056	0.095	0.032	0.096
is_first_booking	0.000	0.026	0.012	0.006	0.022	0.096	0.038	0.040	0.015	0.008	0.038	0.008	0.132	0.000	0.024	0.043	0.081	0.053	0.031	0.030	0.034	0.000	0.038	0.162	0.013	0.096	0.053	0.218	0.479	1.000	0.032	0.043	0.086	0.000	0.000	0.025	0.046	0.012	0.179	0.038
request_nonesmoke	0.000	0.279	0.181	0.179	0.035	0.064	0.039	0.045	0.017	0.029	0.000	0.028	0.049	0.004	0.033	0.036	0.000	0.032	0.201	0.025	0.061	0.000	0.022	0.014	0.014	0.048	0.019	0.074	0.019	0.032	1.000	0.043	0.038	0.091	0.066	0.014	0.038	0.010	0.020	0.021
request_latecheckin	0.000	0.034	0.011	0.009	0.019	0.075	0.021	0.016	0.043	0.000	0.011	0.000	0.085	0.000	0.024	0.023	0.029	0.028	0.029	0.005	0.014	0.012	0.023	0.019	0.017	0.033	0.000	0.081	0.050	0.043	0.043	1.000	0.112	0.039	0.004	0.011	0.029	0.014	0.011	0.023
request_highfloor	0.000	0.104	0.030	0.023	0.036	0.056	0.162	0.088	0.007	0.007	0.010	0.004	0.077	0.000	0.041	0.040	0.033	0.048	0.106	0.011	0.054	0.000	0.057	0.021	0.000	0.093	0.015	0.192	0.119	0.086	0.038	0.112	1.000	0.152	0.045	0.030	0.171	0.043	0.019	0.054
request_largebed	0.000	0.168	0.097	0.092	0.025	0.124	0.097	0.051	0.029	0.099	0.067	0.052	0.117	0.000	0.011	0.012	0.035	0.029	0.131	0.124	0.020	0.004	0.053	0.000	0.031	0.094	0.017	0.150	0.022	0.000	0.091	0.039	0.152	1.000	0.348	0.016	0.038	0.075	0.000	0.052
request_twinbeds	0.000	0.049	0.029	0.027	0.024	0.032	0.078	0.052	0.024	0.080	0.025	0.068	0.069	0.000	0.019	0.016	0.022	0.002	0.028	0.084	0.012	0.014	0.033	0.042	0.031	0.055	0.000	0.104	0.000	0.000	0.066	0.004	0.045	0.348	1.000	0.000	0.002	0.015	0.005	0.033
request_airport	0.000	0.079	0.030	0.027	0.000	0.022	0.032	0.035	0.000	0.033	0.020	0.027	0.031	0.022	0.028	0.012	0.016	0.024	0.069	0.030	0.058	0.008	0.044	0.009	0.044	0.000	0.000	0.125	0.000	0.025	0.014	0.011	0.030	0.016	0.000	1.000	0.014	0.000	0.012	0.022
request_earlycheckin	0.000	0.025	0.000	0.000	0.017	0.052	0.050	0.027	0.000	0.000	0.031	0.000	0.093	0.000	0.000	0.025	0.056	0.038	0.035	0.000	0.000	0.000	0.000	0.028	0.013	0.054	0.000	0.105	0.056	0.046	0.038	0.029	0.171	0.038	0.002	0.014	1.000	0.000	0.000	0.000
did_cancel	0.004	0.265	0.021	0.022	0.117	0.200	0.051	0.062	0.018	0.045	0.043	0.027	0.131	0.018	0.033	0.070	0.089	0.053	0.278	0.059	0.112	0.041	0.387	0.046	0.000	0.148	0.053	0.177	0.095	0.012	0.010	0.014	0.043	0.075	0.015	0.000	0.000	1.000	0.018	0.387
costumer_guest_same_nation	0.000	0.066	0.016	0.009	0.035	0.144	0.037	0.033	0.014	0.008	0.014	0.021	0.144	0.000	0.015	0.049	0.101	0.057	0.061	0.013	0.033	0.020	0.047	0.044	0.000	0.096	0.041	0.394	0.032	0.179	0.020	0.011	0.019	0.000	0.005	0.012	0.000	0.018	1.000	0.047
pay_now	0.000	0.282	0.026	0.023	0.163	0.212	0.096	0.046	0.030	0.059	0.091	0.047	0.168	0.013	0.041	0.093	0.120	0.072	0.287	0.096	0.095	0.028	1.000	0.044	0.034	0.237	0.068	0.205	0.096	0.038	0.021	0.023	0.054	0.052	0.033	0.022	0.000	0.387	0.047	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	h_booking_id	booking_datetime	checkin_date	checkout_date	hotel_id	hotel_country_code	hotel_live_date	hotel_star_rating	accommadation_type_name	charge_option	h_customer_id	customer_nationality	guest_nationality_country_name	no_of_adults	no_of_room	origin_country_code	language	original_selling_amount	original_payment_method	original_payment_type	original_payment_currency	is_user_logged_in	cancellation_policy_code	is_first_booking	request_nonesmoke	request_latecheckin	request_highfloor	request_largebed	request_twinbeds	request_airport	request_earlycheckin	hotel_area_code	hotel_brand_code	hotel_chain_code	hotel_city_code	cancellation_datetime	did_cancel	distance_booking_checkin	amount_guests	amount_nights	price_per_guest_per_night	costumer_guest_same_nation	pay_now
0	7861445258918608962	294	212	213	88838	5	2012-10-04 10:03:00	4.0	16	Pay Now	5310397980746630019	China	China	12	2	CN	37	436.52	Alipay	Credit Card	CNY	True	1D1N_1N	False	1.0	0.0	0.0	0.0	0.0	0.0	0.0	5832	50.0	675.0	461	NaT	False	282	12	1	36.376667	True	True
1	-3175925110616170919	222	222	223	51920	57	2012-10-01 10:03:00	3.0	10	Pay Now	3627650004083420090	Japan	Japan	1	1	JP	26	54.01	American Express	Credit Card	JPY	True	3D1N_1N	False	NaN	NaN	NaN	NaN	NaN	NaN	NaN	643	296.0	191.0	2249	NaT	False	0	1	1	54.010000	True	True
2	-5166200042028380517	257	257	258	90189	114	2014-06-12 08:05:00	4.0	10	Pay Now	6891579066921110017	Taiwan	Taiwan	2	1	TW	43	99.18	Visa	Credit Card	TWD	True	1D1N_1N	False	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2900	NaN	NaN	892	NaT	False	0	2	1	49.590000	True	True
3	6165211278500849566	256	256	257	236389	113	2010-08-31 07:16:00	0.0	5	Pay Now	5915665216707180023	Turkey	Turkey	1	1	TR	46	19.36	MasterCard	Credit Card	TRY	False	365D100P_100P	False	0.0	0.0	0.0	1.0	0.0	0.0	0.0	3110	NaN	NaN	744	NaT	False	0	1	1	19.360000	True	True
4	-1853092131420973567	32	243	245	187085	57	2010-07-01 07:38:00	3.5	10	Pay Later	8271660960620410074	South Korea	South Korea	1	1	KR	27	175.52	Visa	Credit Card	KRW	True	3D100P_100P	False	0.0	0.0	0.0	0.0	0.0	0.0	0.0	3760	453.0	359.0	2260	2018-02-02	True	210	1	2	87.760000	True	False
5	8478973924173415354	172	196	198	788472	109	2015-01-15 15:54:00	3.0	10	Pay Now	1760275406207060063	South Korea	South Korea	2	1	KR	27	68.38	UnionPay - Creditcard	Credit Card	KRW	False	365D100P_100P	False	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1709	NaN	NaN	1636	NaT	False	23	2	2	17.095000	True	True
6	-1853437799368162580	208	231	233	1634464	109	2016-12-19 12:24:00	3.5	10	Pay Later	4700808392292780093	South Korea	South Korea	1	1	KR	8	163.60	Visa	Credit Card	KRW	True	1D1N_100P	False	1.0	0.0	0.0	0.0	0.0	0.0	1.0	2964	442.0	600.0	2477	2018-08-17	True	22	1	2	81.800000	True	False
7	259359728717957150	205	222	225	3002333	109	2017-11-11 20:57:00	2.0	10	Pay Later	3622815626917240092	Thailand	Thailand	2	1	TH	45	48.54	Visa	Credit Card	THB	False	1D1N_1N	False	1.0	0.0	0.0	1.0	0.0	0.0	0.0	2964	NaN	NaN	2477	NaT	False	16	2	3	8.090000	True	False
8	-1624588124260700023	237	258	260	1160850	61	2016-01-27 12:39:00	3.0	10	Pay Now	3580464825046080007	South Korea	South Korea	3	1	KR	27	119.11	UnionPay - Creditcard	Credit Card	KRW	False	7D100P_100P	True	1.0	0.0	0.0	0.0	1.0	0.0	0.0	3901	NaN	NaN	2459	2018-08-25	True	20	3	2	19.851667	True	True
9	8703485699898329335	113	230	231	304893	38	2010-11-17 07:09:00	3.5	10	Pay Now	2129668180375770076	China	China	2	1	CN	37	87.78	UNKNOWN	Invoice	CNY	False	7D50P_2D100P_100P	True	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4806	NaN	NaN	2745	NaT	False	116	2	1	43.890000	True	True

	h_booking_id	booking_datetime	checkin_date	checkout_date	hotel_id	hotel_country_code	hotel_live_date	hotel_star_rating	accommadation_type_name	charge_option	h_customer_id	customer_nationality	guest_is_not_the_customer	guest_nationality_country_name	no_of_adults	no_of_room	origin_country_code	language	original_selling_amount	original_payment_method	original_payment_type	original_payment_currency	is_user_logged_in	cancellation_policy_code	is_first_booking	request_nonesmoke	request_latecheckin	request_highfloor	request_largebed	request_twinbeds	request_airport	request_earlycheckin	hotel_area_code	hotel_brand_code	hotel_chain_code	hotel_city_code	cancellation_datetime	did_cancel	distance_booking_checkin	amount_guests	amount_nights	price_per_guest_per_night	costumer_guest_same_nation	pay_now
46917	-3955370707847627756	147	186	189	289317	45	2011-10-26 16:50:00	1.0	9	Pay Now	2223633554451910061	China	0	China	2	1	CN	37	116.77	WeChat	Credit Card	CNY	True	365D100P_100P	False	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5262	NaN	NaN	142	NaT	False	38	2	3	19.461667	True	True
46918	-7280254002553494006	80	270	271	196931	57	2011-06-29 10:05:00	4.0	10	Pay Later	3057302628167480032	South Korea	0	South Korea	1	1	KR	27	196.43	MasterCard	Credit Card	KRW	True	3D1N_1N	False	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2722	87.0	103.0	1335	2018-03-30	True	189	1	1	196.430000	True	False
46919	8038861849194051967	32	243	245	812762	57	2015-03-11 14:43:00	3.0	10	Pay Later	8271660960620410074	South Korea	0	South Korea	1	1	KR	27	132.78	Visa	Credit Card	KRW	False	28D100P_100P	True	0.0	0.0	0.0	0.0	0.0	0.0	0.0	3760	NaN	NaN	2260	2018-02-02	True	210	1	2	66.390000	True	False
46920	-5687848489097746853	180	215	218	868632	57	2015-02-26 16:35:00	1.0	9	Pay Now	989627699560000000	South Korea	0	South Korea	1	1	KR	27	87.01	Visa	Credit Card	KRW	True	2D50P_100P	False	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3950	NaN	NaN	220	2018-07-03	True	34	1	3	29.003333	True	True
46921	4805148141901219862	173	245	247	3132844	61	2017-11-06 16:47:00	3.0	10	Pay Now	4543871625495590025	Taiwan	0	Taiwan	3	1	TW	43	183.54	Visa	Credit Card	TWD	True	3D100P	False	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5242	NaN	NaN	731	NaT	False	71	3	2	30.590000	True	True
46922	7859361556233200164	258	259	260	2504240	57	2017-07-08 14:23:00	3.0	18	Pay Now	2856938804428580064	Japan	0	Japan	2	1	JP	26	142.68	UNKNOWN	Credit Card	JPY	False	2D100P	True	1.0	0.0	0.0	1.0	0.0	0.0	0.0	185	NaN	NaN	2039	NaT	False	0	2	1	71.340000	True	True
46923	2778941468684758600	265	270	272	2613173	57	2017-08-15 07:07:00	2.0	5	Pay Now	8706898603750380065	South Korea	0	South Korea	1	1	KR	27	49.74	MasterCard	Credit Card	KRW	True	1D50P_100P	False	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4463	NaN	NaN	2567	2018-09-22	True	4	1	2	24.870000	True	True
46924	-8952794303652718161	95	203	205	276008	61	2014-06-19 08:05:00	3.5	10	Pay Later	2011401455184750047	Taiwan	0	Taiwan	3	1	TW	43	140.12	Visa	Credit Card	TWD	True	7D50P_2D100P_100P	False	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1240	188.0	454.0	731	2018-04-05	True	107	3	2	23.353333	True	False
46925	-4286304901316077629	212	213	215	1573295	114	2016-10-04 13:32:00	3.0	10	Pay Now	7713317830746380044	Taiwan	1	Taiwan	2	1	TW	43	87.30	MasterCard	Credit Card	TWD	True	2D100P	False	1.0	0.0	0.0	0.0	0.0	0.0	0.0	5208	NaN	NaN	2004	NaT	False	0	2	2	21.825000	True	True
46926	8516014471330804625	207	241	242	91737	52	2009-06-28 02:02:00	3.5	10	Pay Later	2430631550982440067	Bangladesh	1	Bangladesh	2	1	BD	8	58.01	MasterCard	Credit Card	USD	True	2D1N_1N	False	0.0	0.0	0.0	1.0	0.0	0.0	0.0	2597	NaN	NaN	2302	NaT	False	33	2	1	29.005000	True	False

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Dash Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories